# Insert statements for project IT010

INSERT INTO project (`code`, `title`, `manager`, `budget`) VALUES ("IT010", "Pensions", "K. Jones", 123000);

INSERT INTO department(`id`, `name`) VALUES (10, "IT"), (40, "HR"), (20, "DBA"), (30, "Accounts");

INSERT INTO employee(`id`, `name`, `hourly_rate`, `department_id`, `project_id`) VALUES (100, "P. Lewis", 23.43, 10, 1);
INSERT INTO employee(`id`, `name`, `hourly_rate`, `department_id`, `project_id`) VALUES (102, "S. Smith", 34.21, 40, 1);
INSERT INTO employee(`id`, `name`, `hourly_rate`, `department_id`, `project_id`) VALUES (104, "H. Finn", 35.21, 40, 1);